Film_Locations_in_San_Francisco

Data source: data.sfgov.org

30 rows where Actor 1 = 273

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Production Company, Distributor, Director, Writer, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
211 211 Bullitt 42 1968 31 Bayshore Blvd near Cesar Chavez (Bayview)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
212 212 Bullitt 42 1968 31 Taylor & Vallejo Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
214 214 Bullitt 42 1968 31 SF General Hospital Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
215 215 Bullitt 42 1968 31 McLaren Park (Visitacion Valley) McLaren Park is the 2nd largest park in San Francisco, after Golden Gate Park. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
216 216 Bullitt 42 1968 31 Mark Hopkins Hotel (999 California Street) The Top of the Mark lounge and restaurant at the top of the hotel was formerly a penthouse suite. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
217 217 Bullitt 42 1968 31 Marina Green (Marina District) Before the 1906 earthquake, the land on which Marina Green sits was a tidal marsh, and rubble from the earthquake was dumped on the site. However, the site was filled in to provide land for the 1915 Panama-Pacific Exhibition. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
218 218 Bullitt 42 1968 31 Mansell & University Streets (Visitacion Valley)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
219 219 Bullitt 42 1968 31 Larkin & Francisco Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
220 220 Bullitt 42 1968 31 Larkin & Chestnut Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
221 221 Bullitt 42 1968 31 Kennedy Hotel (226 Embarcadero at Howard Street) Hotel was destroyed in the 1989 Loma Prieta earthquake. Corporate headquarters for the Gap reside at the location today. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
222 222 Bullitt 42 1968 31 John Muir Drive (Lake Merced)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
223 223 Bullitt 42 1968 31 Intersection of York & Peralta (Bernal Heights)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
224 224 Bullitt 42 1968 31 Filbert & Taylor Streets (Russian Hill)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
225 225 Bullitt 42 1968 31 Enrico's Café (504 Broadway)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
226 226 Bullitt 42 1968 31 Columbus & Lombard Streets (North Beach)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
227 227 Bullitt 42 1968 31 Cesar Chavez & Mission Street (Mission)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
228 228 Bullitt 42 1968 31 Candlestick Park Exit, Highway 101   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
229 229 Bullitt 42 1968 31 Café Cantata (2040 Union Street)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
230 230 Bullitt 42 1968 31 Brocklebank Apartments (1000 Mason Street)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
231 231 Bullitt 42 1968 31 Bay Bridge Before opening in 1936, the bridge was blessed by Cardinal Secretary of State Eugenio Pacelli, who later became Pope Pius XII. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
232 232 Bullitt 42 1968 31 2700 Vallejo Street (Pacific Heights)   Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
233 233 Bullitt 42 1968 31 20th & Vermont Streets (Potrero Hill) The most crooked street in San Francisco is actually Potrero Hill's Vermont Street between 20th St & 22nd St. Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
234 234 Bullitt 42 1968 31 1153-57 Taylor Street Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) Warner Brothers / Seven Arts Seven Arts 37 Warner Brothers 30 Peter Yates 40 Alan R. Trustman 39 Steve McQueen 273 Jacqueline Bisset 36 Robert Vaughn 459
1481 1481 The Towering Inferno 278 1974 49 2898 Vallejo Street   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1497 1497 The Towering Inferno 278 1974 49 Bank of America Building (555 California Street, Financial District) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1498 1498 The Towering Inferno 278 1974 49 San Francisco Fire Station 38 (2150 California Street, Pacific Heights)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1499 1499 The Towering Inferno 278 1974 49 Hyatt Regency Hotel (5 Embarcadero Center, Financial District)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1500 1500 The Towering Inferno 278 1974 49 Grace Cathedral Episcopal Church (1100 California Street) Grace Cathedral Episcopal Church is the West Coast's largest Episcopalian cathedral. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1501 1501 The Towering Inferno 278 1974 49 Firestation #38 (California & Laguna)   Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542
1502 1502 The Towering Inferno 278 1974 49 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Irwin Allen Productions 162 Twentieth Century - Fox 112 John Guillermin 228 Stirling Silliphant 222 Steve McQueen 273 Paul Newman 214 William Holden 542

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 34.947ms · Data source: data.sfgov.org